import pandas as pd
import matplotlib.pyplot as plt


df1 = pd.read_excel("/Users/andy/Downloads/013/Orders.xlsx", index_col="Week")
df1.plot(y=["Accessories","Bikes","Clothing","Components"])
#生成折线图的时候, 使用上面的命令即可
df1.plot.area(y=["Accessories","Bikes","Clothing","Components"])
#如果要生成叠加区域的折线图, 则加上.area
plt.title("Sales Weekly Trend", fontsize=16, fontweight="bold")
plt.xticks(df1.index, fontsize=10)
plt.show()







